﻿CREATE TABLE [dbo].[CIMaidinfo]
(
[aid] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[infoFilled] [bit] NULL,
[cashFilled] [bit] NULL,
[bankDone] [bit] NULL,
[firmDone] [bit] NULL,
[archivestate] [int] NULL
) ON [PRIMARY]


GO
EXEC sp_addextendedproperty N'MS_Description', N'[面向银行]贷款还清标记', 'SCHEMA', N'dbo', 'TABLE', N'CIMaidinfo', 'COLUMN', N'bankDone'
GO
EXEC sp_addextendedproperty N'MS_Description', N'[面向公司]垫款记录为0', 'SCHEMA', N'dbo', 'TABLE', N'CIMaidinfo', 'COLUMN', N'firmDone'

